[QUIZ] Check your understanding of SQL - Part 2

Question 1: In SQL, how to insert a new record into the "Persons" table?
1. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
2. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
3. INSERT ('Jimmy', 'Jackson') INTO Persons
Question 2: In SQL, how to insert the record "LastName" worth "Olsen" in the "Persons" table?
1. INSERT ('Olsen') INTO Persons (LastName)
2. INSERT INTO Persons ('Olsen') INTO LastName
3. INSERT INTO Persons (LastName) VALUES ('Olsen')
Question 3: How to change "Hansen" to "Nilsen" in the "LastName" column in the "Persons" table?
1. MODIFY Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'
2. UPDATE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'
3. MODIFY Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen
4. UPDATE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen'
Question 4: In SQL, how to delete the "Peter" record from the "FirstName" column in the "Persons" table?
1. DELETE FirstName = 'Peter' FROM Persons
2. DELETE ROW FirstName = 'Peter' FROM Persons
3. DELETE FROM Persons WHERE FirstName = 'Peter'
Question 5: In SQL, how to return the number of records in the "Persons" table?
1. SELECT COLUMNS (*) FROM Persons
2. SELECT COUNT (*) FROM Persons
3. SELECT LEN (*) FROM Persons
4. SELECT NO (*) FROM Persons
Question 6: Where is the most popular type of JOIN?
1. INNER JOIN
2. INSIDE JOIN
3. JOINED TABLE
4. JOINED
Question 7: Which operator is used to retrieve data in a range?
1. RANGE
2. BETWEEN
3. WITHIN
Question 8: The NOT NULL constraint does not accept a null value column.
1. It's correct
2. False
Question 9: Which clauses are used to find values according to certain patterns?
1. LIKE
2. GET
3. FROM
Question 10: Which SQL statement is used to create the table in the database?
1. CREATE DB
2. CREATE TABLE
3. CREATE DATABASE TAB
4. CREATE DATABASE TABLE

Samuel Daniel

Update 24 May 2019

You should read it

May be interested

[QUIZ] Test your understanding of SQL - Part 3
the test set comes with sql lessons that give you lots of useful knowledge.
[QUIZ] Test your understanding of SQL - Part 4
let's try our knowledge with multiple choice questions about sql database management system.
[QUIZ] Test your understanding of SQL - Part 5
multiple-choice questions on sql help you familiarize and review useful knowledge for work and learning sql language.
[QUIZ] Test your understanding of SQL - Part 6
in order to serve your work and your study, along with sql lessons, quantrimang offers a variety of useful questions.
[QUIZ] Test your understanding of SQL - Part 7
part 7 of the sql quiz goes into the sql practice exercises that follow the previous period.
Test of CSS knowledge - Part 5
set of multiple choice questions about css programming language, invite readers to test their knowledge on this topic. with 15 questions including many answers, choose the best answer.

[QUIZ] Check your understanding of SQL - Part 2

You should read it

May be interested

Quiz technology